﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<!-- saved from url=(0029)http://www.helpandmanual.com/ -->
<head> 
   <!-- Premium Pack Version 1.24 Template design (c) copyright 2008-2009 by Tim Green and EC Software -->
   <title>Export</title> 
   <meta name="generator" content="Help &amp; Manual" /> 
   <meta name="keywords" content="" />
   <meta name="description" content="Export" />
   <meta name="copyright" content="© 2012 Futures Group" /> 
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />                                         
   <link type="text/css" href="default.css" rel="stylesheet" />
   <link type="text/css" href="custom.css" rel="stylesheet" />
   <script type="text/javascript" src="jquery-1.3.2.min.js"></script>
   <script type="text/javascript" src="jquery.scrollTo-min.js"></script>
   <script type="text/javascript" src="nsh.js"></script>

<script type="text/javascript">

</script>



<style type="text/css">
   .help-url { font-size: 8pt; font-family: Verdana, Helvetica, sans-serif; 
               color: #000; text-align: center; margin: 15px 20px 20px 0px; 
               padding-top: 5px; border-top: 1px solid #000;}
   .help-url a { color: #000; text-decoration: none; }
   .help-url a:visited { color: #000; }
   .help-url a:hover { color: #000; text-decoration: underline; }
   .highlight {background: #ffff40;}
</style>







<!-- CSS set with project variables and local attributes --> 
<style type="text/css" media="screen"> 
   body { background: #fff; } 
   #breadcrumbs { width: 100%; background-color: white; border: 1px solid #000; padding: 2px 0 1px 2px;
   margin: 3px 0; font-size: 8pt; color: #000;}
   #breadcrumbs a { color: #000; text-decoration: none;}
   #breadcrumbs a:visited { color: #000; }
   #breadcrumbs a:hover { color: #098ae2; text-decoration: none; }
</style> 

<!-- Adjustment for IE -->
<!--[if lte IE 8]>
<style type="text/css">
.topichead { padding-right: 0; }
#autoTocWrapper ul li { padding: 3px 3px 4px 3px;}

   .breadhead {
   margin: 0;
   padding-right: 5px;
   }
   img#togtoc {
       bottom:1px; 
    }   

   
</style>
<![endif]-->
   
<script type="text/javascript">
// Initialize the page 
addEvent(window, "load", nsrInit);
addEvent(window, "load", doResize);
addEvent(window, "resize", doResize);
if (!$.browser.msie) {
addEvent(window, "load", toggleJump);
}
</script>

<script type="text/javascript" src="helpman_topicinit.js"></script>
<!-- Redirect browser to frame page if page is not in the content frame. -->
<script type="text/javascript">
<!--
if (location.search.lastIndexOf("toc=0")<=0) {
  if (parent.frames.length==0) { parent.location.href="index.html?export.htm"; }
  else { parent.quicksync('a4.11'); }
}
//-->
</script>
<script type="text/javascript" src="highlight.js"></script></head> 
<body onload="highlight();">
<div id="hmpopupDiv" style="visibility:hidden; position:absolute; z-index:1000; "></div>
<!--ZOOMSTOP-->

<div id="printheader">
<span id="printtitle">IQCare User Guide V3.2</span><br />
<p class="p_Heading1"><span class="f_Heading1">Export</span></p>
</div>
<div id="idheader" style= "background: #a7d7f8 url('bg_topichd.gif') repeat-x bottom;"> 
<table id="breadtable" width="100%" border="0" cellspacing="0" cellpadding="0"> 
  <tr >
  <td align="left" class="breadhead" height="5">
        
  </td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="headtable"> 

<!-- Script version of NavHeader -->
<tr id="scriptNavHead" valign="middle" style="height: auto;">
   
   <td align="left" class="topichead">
   <p class="p_Heading1"><span class="f_Heading1">Export</span></p>

   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="refresh_reporting_tables.htm"
        onmouseover="document.images.prev.src='button_prev_h.gif'" 
        onmouseout="document.images.prev.src='button_prev.gif'">
        <img name="prev" src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="exporting_data.htm"
        onmouseover="document.images.next.src='button_next_h.gif'" 
        onmouseout="document.images.next.src='button_next.gif'"><img name="next" src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>
   
   
   
  
   <td width="4">&nbsp;</td>
  </tr>
<!-- End script navheader version -->

<!-- NoScript version of navheader -->
  <tr id="noScriptNavHead" valign="middle" style="height: auto;"> 
    <td align="left" class="topichead"> 
    <p class="p_Heading1"><span class="f_Heading1">Export</span></p>

    </td>
    <td align="center" width="20" class="idnav" valign="bottom">
     <a href="refresh_reporting_tables.htm">
        <img src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="exporting_data.htm">
        <img src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>
   
   
   
   
   <td width="4">&nbsp;</td>
  </tr>
<!-- End noscript navheader version -->
  </table>
<div id="autoTocWrapper"></div>
</div> 

<div id="idcontent"><div id="innerdiv">
<!--ZOOMRESTART-->
<p>IQCare gives you several options for exporting data. One option is found under the Export feature where you can export groups of data to Excel. The other way to export data is through the <a href="custom_reports.htm">Custom Report</a> feature where once you create a report, the results can be exported to Excel.</p>
<p>&nbsp;</p>
<p><span style="font-weight: bold;">Field Groups</span></p>
<p>All of IQCare data has been organized by like-field groupings which are used for the <a href="customreportfieldgroups_ar.htm">reporting table structure</a>. For example all of the patient demographic data is grouped together in the Patient Demographic field group. These same field grouping are also used for Custom Reports. You can export one or more groups of fields to Excel.</p>
<p>&nbsp;</p>
<p>When exporting field groups to Excel, there is a maximum of 256 fields that can be exported. This is the maximum number of fields that can be placed horizontally in an Excel spreadsheet. This limitation is based on the Microsoft Web Office Objects that is used to create the spreadsheets in the browser.</p>
<p>&nbsp;</p>
<p><span style="font-weight: bold;">De-Identifying Data </span></p>
<p>When you check the De-Identify Data check box, a specific set of fields will not be displayed should you have selected field groupings that contain data that identifies the patient. &nbsp;The fields are:</p>
<p>&nbsp;</p>
<p><span style="font-weight: bold;"><a class="dropdown-toggle" href="javascript:HMToggle('toggle','TOGGLE0186A1')">HIV Care Static Form Set</a></span></p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 10px;"><table id="TOGGLE0186A1" class="toggletable" cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p>This is the set of data from the HIV Care Static form set that are de-identified.</p>
<p>&nbsp;</p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 10px;"><table cellspacing="0" cellpadding="4" border="0" style="border: none; border-spacing:0px; border-collapse: collapse;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="330" bgcolor="#e0e0e0" style="width:330px; background-color:#e0e0e0; border: solid 1px #000000;"><p><span style="font-weight: bold;">Field Group</span></p>
</td>
<td valign="top" width="330" bgcolor="#e0e0e0" style="width:330px; background-color:#e0e0e0; border: solid 1px #000000;"><p><span style="font-weight: bold;">Fields</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="330" style="width:330px; border: solid 1px #000000;"><p>Patient Demographics</p>
</td>
<td valign="top" width="330" style="width:330px; border: solid 1px #000000;"><p>Local Council</p>
<p>Patient Address</p>
<p>Patient First Name</p>
<p>Patient Last Name</p>
<p>Patient Name</p>
<p>Patient Phone</p>
<p>Province</p>
<p>Village</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="330" style="width:330px; border: solid 1px #000000;"><p>Patient Contacts</p>
</td>
<td valign="top" width="330" style="width:330px; border: solid 1px #000000;"><p>Emergency Contact Address</p>
<p>Emergency Contact Name</p>
<p>Emergency Contact Phone</p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="330" style="width:330px; border: solid 1px #000000;"><p>Family Information</p>
</td>
<td valign="top" width="330" style="width:330px; border: solid 1px #000000;"><p>Family Member Name</p>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>

<!--ZOOMSTOP--> 

</div></div> 
<script type="text/javascript">
HMInitToggle('TOGGLE0186A1','hm.type','dropdown','hm.state','0');
</script>
</body>
<!--[if IE]>
<script type="text/javascript" defer="defer">
$("#hmcontent",window.parent.document).ready(function() {
var doTogJump=setTimeout("toggleJump()", 0);
      });
</script>
<![endif]-->
</html>
